Formatting Numeric Fields

When creating or editing a numeric field type, you can use the following characters to control the data entry format for the end user:

• Use all blanks as the default; the data will be captured as is with no validation.
• Use a nine (9) to accept any number (0-9) in the specified position of the field. For example, 9999 allows the user to enter a 4 digit number.
• Use a comma (,) to automatically insert a comma in the specified position(s) of the field, for example, 99,999,999.
• Use a decimal point (.) to accept only a decimal point in the specified position, for example, 999.99
• Use a Z to automatically suppress leading zeros in the specified position(s) of the field. For example ZZ99 would allow a user to enter the number 05, but not 005 or 0005.
• Use a single dollar sign ($) to automatically insert a dollar sign in the specified position of the field, for example: $999.99.
• Use two dollars signs if you want to suppress leading zeroes, for example, $$999.99
• Use a % to specific a percentage amount, for example 99.99%.

See Also

• Editing an Element
• Editing a Resource Using the Manage Resources Dialog
• Creating a Resource
• Inserting a Field Element